import pandas as pd
import numpy as np

from bokeh.plotting import figure, show
from bokeh.io import curdoc, show, output_notebook
from bokeh.models import ColumnDataSource, HoverTool


output_notebook()

world_data = pd.read_csv('/home/jericho/country_profile_variables.csv')
world_data = world_data.set_index('country')

covid_data = pd.read_json('https://pomber.github.io/covid19/timeseries.json')

for country in world_data.index:
    try:
        world_data.loc[country, 'COVID19_confirmed'] = covid_data[country][328]['confirmed']
        world_data.loc[country, 'COVID19_recovered'] = covid_data[country][328]['recovered']
        world_data.loc[country, 'COVID19_deaths'] = covid_data[country][328]['deaths']
    except KeyError:
        pass

del world_data['Region']

for i in world_data.columns:

    #create Figure
    p = figure()

    #create Scatter in Figure
    exec("p.scatter(x='"+i+"', y='COVID19_deaths', marker='x', source=ColumnDataSource(world_data), line_color='#6666ee', fill_color='#ee6666', fill_alpha=0.5, size=12)")

    #set x/y axis labels
    exec("p.xaxis.axis_label = '"+i+"'")
    p.yaxis.axis_label = 'COVID19_deaths'


    #create Hover for Scatter
    p_hover = HoverTool()
    exec("p_hover.tooltips = [('Country', '@country'),('Deaths', '@COVID19_deaths')]")
    p.add_tools(p_hover)

    show(p)

Loading BokehJS ...